/**
 * @filename:PrdTaskQtyDao Dec 22, 2023
 * Copyright(c) 2020 Wonder Co. Ltd. 
 * All right reserved. 
 */
package com.wonder.app.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import com.wonder.app.domain.PrdTaskQty;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Service;

import java.util.List;

/**   
 * @Description:TODO(生产订单员工数据访问层)
 * @author: Wonder
 * 
 */
@Mapper
public interface PrdTaskQtyDao extends BaseMapper<PrdTaskQty> {


    //查询员工在每天的每个车间的工时
    List<PrdTaskQty> selectWorkTimeList(String startTime,String endTime,Long size ,Long pages,String userName);

    /**
     * 查询员工在每天的每个车间的工时(查询总数)
     * @param startTime
     * @param endTime
     * @return
     */
    int selectWorkTimeCount(String startTime, String endTime,String userName);

    /**
     * 员工计件分配系数报表
     * @param startTime
     * @param endTime
     * @param size
     * @param pages
     * @return
     */
    List<PrdTaskQty> getPieceRote(String startTime, String endTime, long size, long pages,String userName);

    /**
     * 员工计件分配报表数量
     * @param startTime
     * @param endTime
     * @return
     */
    int getPieceRoteTotal(String startTime, String endTime,String userName);
}
